Labels:text | screenshot | font | number | document OCR: Name Description ADD MONTHS Adds the specified number of months to a date. If you want to shift forward by a year, simply enter ADD MONTHS (my_date, 12). LAST_DAY Returns the last day in the month of the specified date. You no longer have to remember the nursery rhyme, "30 days hath September ... ". MONTHS _BETWEEN Calculates the number of months between two dates. This function also returns a decimal value for fractional components of months. NEW TIME Returns the date/time value, with the time shifted as requested by the specified time zones. NEXT DAY Returns the date of the first weekday specified that is later than the date. To find the first Sunday in March, you would type NEXT_DAY ('01-MAR-96', 'SUNDAY"). ROUND Returns the date rounded by the specified format unit. You can round to the nearest year (first day in the year), month, quarter, etc. SYSDATE Returns the current date and time in the Oracle Server. The precision for SYSDATE is seconds. TRUNC Truncates the specified date of its time portion and according to the format unit provided. Similar to TRUNC, but it simply chops off all but the desired component. For example, TRUNC(my_date) "zeroes out" (to midnight) the time stamp.
